package org.zoomdev.zoom.dao.utils;

import java.util.regex.Pattern;

public class SqlUtils {
    public static final Pattern AS_PATTERN = Pattern.compile("([a-z_\\(\\)\\.\\[\\]+\\-\\*/',\\s]+)[\\s]+as[\\s]+([a-z_]+)", Pattern.CASE_INSENSITIVE);
    public static final Pattern TABLE_AND_COLUMN_PATTERN = Pattern.compile("([a-zA-Z0-9_]+[\\s]*)\\.[\\s]*([a-zA-Z0-9_]+|[a-zA-Z0-9_]+)", Pattern.CASE_INSENSITIVE);
    public static final Pattern AND_OR_PATTERN = Pattern.compile("[\\s]+(and)[\\s]+|[\\s]+(or)[\\s]+", Pattern.CASE_INSENSITIVE);
}
